/*
*
* Copyright (c) 2011 Vaulting Systems International
* 
* Permission is hereby granted, free of charge, to any person obtaining a copy 
* of this software and associated documentation files (the "Software"), to deal 
* in the Software without restriction, including without limitation the rights 
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies 
* of the Software, and to permit persons to whom the Software is furnished to do  
* so, subject to the following conditions:
*
* The above copyright notice and this permission notice shall be included in all  
* copies or substantial portions of the Software.
*
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, 
* INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A 
* PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT 
* HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION 
* OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE  
* SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
*
*/
package com.ekeyman.securecreditlib.dao;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.ekeymanlib.dto.SearchFilter;
import com.ekeyman.securecreditlib.util.DaoUtils;

public abstract class AbstractDao extends HibernateDaoSupport {

	
	@SuppressWarnings("unchecked")
	public long getCount(List<SearchFilter> searchFilters, Class clazz) {
		
		Long rowCount  = new Long(0);

		DetachedCriteria criteria = DetachedCriteria.forClass(clazz);
		criteria.setProjection(Projections.rowCount());
		
		DaoUtils.buildSearchCriteria(criteria, searchFilters);	
		
		List results = getHibernateTemplate().findByCriteria(criteria);
		
        if(results != null && !results.isEmpty()){
        	rowCount = (Long) results.get(0); 
        }
        else {
        	rowCount = new Long(0);
        }
		
		return rowCount;
	}
	
	@SuppressWarnings("unchecked")
	public List findAll(List<SearchFilter> searchFilters, Class clazz, 
			String sortIndex, String sortOrder, int firstResult, int maxResults) {
		
		DetachedCriteria criteria = DetachedCriteria.forClass(clazz);
	    criteria.setProjection(null);
	    criteria.setResultTransformer(Criteria.ROOT_ENTITY);

		DaoUtils.buildSearchCriteria(criteria, searchFilters);	
		
	    if (sortIndex != null && !sortIndex.equalsIgnoreCase("")) {
	        if (sortOrder.equalsIgnoreCase("asc")) {
	        	criteria.addOrder(Order.asc(sortIndex));
	        }
	        else {
	        	criteria.addOrder(Order.desc(sortIndex));
	        }
	    }
		
		return getHibernateTemplate().findByCriteria(criteria, firstResult, maxResults);
	}
	
}
